{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Opportunity cost calculator","Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Opportunity cost calculator","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Additional costs of approving a new technology (each year, £m)",80]
[null,"As a percentage of a 1% change in the NHS budget",{"$f":"C1/Calculation!F1","v":0.1020434194749866}]
[]
[null,null,"Change in NHS spend (£m)","Additional deaths","Life years lost","Total QALYs lost","QALYs lost due to premature death","QALYs lost due to effects on quality of life"]
[null,"Totals",{"$f":"SUM(C6:C27)","v":79.999999999999986},411.23283823942222,1863.7647528787909,6186.0120629724033,1198.206755992818,4987.8053069795851]
[null,"Cancer",{"$f":"Calculation!H3*$C$2","v":3.5796872783109981},{"$f":"Calculation!K3*$C$2","v":29.940698791364973},{"$f":"Calculation!L3*$C$2","v":300.02328209768399},{"$f":"Calculation!M3*$C$2","v":210.60531457135536},{"$f":"Calculation!N3*$C$2","v":195.09343312478734},{"$f":"Calculation!O3*$C$2","v":15.511881446567994}]
[null,"Circulatory ",{"$f":"Calculation!H4*$C$2","v":6.0714773827633319},{"$f":"Calculation!K4*$C$2","v":182.23857945867081},{"$f":"Calculation!L4*$C$2","v":927.82683981584194},{"$f":"Calculation!M4*$C$2","v":862.61954475776292},{"$f":"Calculation!N4*$C$2","v":589.60334320750712},{"$f":"Calculation!O4*$C$2","v":273.0162015502558}]
[null,"Respiratory ",{"$f":"Calculation!H5*$C$2","v":3.6662913326853013},{"$f":"Calculation!K5*$C$2","v":106.96298664527413},{"$f":"Calculation!L5*$C$2","v":128.51359644712034},{"$f":"Calculation!M5*$C$2","v":1834.8093762481685},{"$f":"Calculation!N5*$C$2","v":80.474087046729466},{"$f":"Calculation!O5*$C$2","v":1754.3352892014391}]
[null,"Gastro-intestinal ",{"$f":"Calculation!H6*$C$2","v":2.5609446660378756},{"$f":"Calculation!K6*$C$2","v":20.926370606516645},{"$f":"Calculation!L6*$C$2","v":197.25277060655907},{"$f":"Calculation!M6*$C$2","v":351.13742580952987},{"$f":"Calculation!N6*$C$2","v":129.425741275706},{"$f":"Calculation!O6*$C$2","v":221.71168453382387}]
[null,"Infectious diseases",{"$f":"Calculation!H7*$C$2","v":2.6124188394968013},{"$f":"Calculation!K7*$C$2","v":5.7687428463362309},{"$f":"Calculation!L7*$C$2","v":42.529364805880292},{"$f":"Calculation!M7*$C$2","v":125.4228190064578},{"$f":"Calculation!N7*$C$2","v":28.754026013462386},{"$f":"Calculation!O7*$C$2","v":96.668792992995421}]
[null,"Endocrine ",{"$f":"Calculation!H8*$C$2","v":1.5141215201459173},{"$f":"Calculation!K8*$C$2","v":5.3911039475676104},{"$f":"Calculation!L8*$C$2","v":39.71722038636333},{"$f":"Calculation!M8*$C$2","v":484.61309674594042},{"$f":"Calculation!N8*$C$2","v":25.963539736522936},{"$f":"Calculation!O8*$C$2","v":458.64955700941749}]
[null,"Neurological ",{"$f":"Calculation!H9*$C$2","v":4.7821803425635032},{"$f":"Calculation!K9*$C$2","v":9.649224379971221},{"$f":"Calculation!L9*$C$2","v":51.82143699571288},{"$f":"Calculation!M9*$C$2","v":872.59426689975066},{"$f":"Calculation!N9*$C$2","v":34.153471769167012},{"$f":"Calculation!O9*$C$2","v":838.44079513058364}]
[null,"Genito-urinary ",{"$f":"Calculation!H10*$C$2","v":3.7083522974314893},{"$f":"Calculation!K10*$C$2","v":17.979645344057104},{"$f":"Calculation!L10*$C$2","v":26.161905609215061},{"$f":"Calculation!M10*$C$2","v":84.641010190165929},{"$f":"Calculation!N10*$C$2","v":16.516215839362342},{"$f":"Calculation!O10*$C$2","v":68.124794350803583}]
[null,"Trauma & injuries*",{"$f":"Calculation!H11*$C$2","v":6.1591612952116206},{"$f":"Calculation!K11*$C$2","v":0},{"$f":"Calculation!L11*$C$2","v":0},{"$f":"Calculation!M11*$C$2","v":0},{"$f":"Calculation!N11*$C$2","v":0},{"$f":"Calculation!O11*$C$2","v":0}]
[null,"Maternity & neonates*",{"$f":"Calculation!H12*$C$2","v":5.460604345316507},{"$f":"Calculation!K12*$C$2","v":4.5470718687433208E-2},{"$f":"Calculation!L12*$C$2","v":3.3941830124604775},{"$f":"Calculation!M12*$C$2","v":3.6781554556968201},{"$f":"Calculation!N12*$C$2","v":2.5309761208762724},{"$f":"Calculation!O12*$C$2","v":1.1471793348205477}]
[null,"Disorders of Blood",{"$f":"Calculation!H13*$C$2","v":1.6453517301540261},{"$f":"Calculation!K13*$C$2","v":2.9185815473904806},{"$f":"Calculation!L13*$C$2","v":13.227419871712385},{"$f":"Calculation!M13*$C$2","v":174.68947997441092},{"$f":"Calculation!N13*$C$2","v":8.9859142097813596},{"$f":"Calculation!O13*$C$2","v":165.70356576462953}]
[null,"Mental Health ",{"$f":"Calculation!H14*$C$2","v":14.285359394752923},{"$f":"Calculation!K14*$C$2","v":22.663372810293218},{"$f":"Calculation!L14*$C$2","v":102.71357609964051},{"$f":"Calculation!M14*$C$2","v":762.13375920228907},{"$f":"Calculation!N14*$C$2","v":66.514415696205461},{"$f":"Calculation!O14*$C$2","v":695.61934350608294}]
[null,"Learning Disability",{"$f":"Calculation!H15*$C$2","v":0.82949150123889759},{"$f":"Calculation!K15*$C$2","v":0.34873433742606358},{"$f":"Calculation!L15*$C$2","v":1.5805128038797973},{"$f":"Calculation!M15*$C$2","v":5.5342502866754471},{"$f":"Calculation!N15*$C$2","v":1.0929175441008685},{"$f":"Calculation!O15*$C$2","v":4.4413327425745797}]
[null,"Problems of Vision",{"$f":"Calculation!H16*$C$2","v":1.5542522561835868},{"$f":"Calculation!K16*$C$2","v":0.41376484066848379},{"$f":"Calculation!L16*$C$2","v":1.8752401421052245},{"$f":"Calculation!M16*$C$2","v":33.94472443894113},{"$f":"Calculation!N16*$C$2","v":1.3438676136645635},{"$f":"Calculation!O16*$C$2","v":32.600856825276566}]
[null,"Problems of Hearing",{"$f":"Calculation!H17*$C$2","v":0.6992285174326508},{"$f":"Calculation!K17*$C$2","v":0.25912532240008262},{"$f":"Calculation!L17*$C$2","v":1.1743922118069072},{"$f":"Calculation!M17*$C$2","v":112.07249750910253},{"$f":"Calculation!N17*$C$2","v":0.84744742055422473},{"$f":"Calculation!O17*$C$2","v":111.22505008854829}]
[null,"Dental problems",{"$f":"Calculation!H18*$C$2","v":2.3097615122180413},{"$f":"Calculation!K18*$C$2","v":1.7946402616122313E-2},{"$f":"Calculation!L18*$C$2","v":8.1335607292691292E-2},{"$f":"Calculation!M18*$C$2","v":54.383533401628227},{"$f":"Calculation!N18*$C$2","v":5.2054580455220101E-2},{"$f":"Calculation!O18*$C$2","v":54.331478821173}]
[null,"Skin",{"$f":"Calculation!H19*$C$2","v":1.5723662770178781},{"$f":"Calculation!K19*$C$2","v":1.9555074700723254},{"$f":"Calculation!L19*$C$2","v":8.8626334227473968},{"$f":"Calculation!M19*$C$2","v":15.561456500744228},{"$f":"Calculation!N19*$C$2","v":5.7274507664507537},{"$f":"Calculation!O19*$C$2","v":9.8340057342934646}]
[null,"Musculo skeletal ",{"$f":"Calculation!H20*$C$2","v":2.9015448552383023},{"$f":"Calculation!K20*$C$2","v":3.1235373733505711},{"$f":"Calculation!L20*$C$2","v":14.1563083475378},{"$f":"Calculation!M20*$C$2","v":185.66654791460007},{"$f":"Calculation!N20*$C$2","v":9.2246284687930338},{"$f":"Calculation!O20*$C$2","v":176.44191944580697}]
[null,"Poisoning and AE",{"$f":"Calculation!H21*$C$2","v":0.74218208976541977},{"$f":"Calculation!K21*$C$2","v":0.35934208706272458},{"$f":"Calculation!L21*$C$2","v":1.6285886092187207},{"$f":"Calculation!M21*$C$2","v":6.5364059045683902},{"$f":"Calculation!N21*$C$2","v":1.0641202030565293},{"$f":"Calculation!O21*$C$2","v":5.4722857015118596}]
[null,"Healthy Individuals",{"$f":"Calculation!H22*$C$2","v":2.8279145846342453},{"$f":"Calculation!K22*$C$2","v":0.27010330969592611},{"$f":"Calculation!L22*$C$2","v":1.2241459860121471},{"$f":"Calculation!M22*$C$2","v":5.3683981546155524},{"$f":"Calculation!N22*$C$2","v":0.83910535563489286},{"$f":"Calculation!O22*$C$2","v":4.5292927989806593}]
[null,"Social Care Needs",{"$f":"Calculation!H23*$C$2","v":2.4035838616970717},{"$f":"Calculation!K23*$C$2","v":0},{"$f":"Calculation!L23*$C$2","v":0},{"$f":"Calculation!M23*$C$2","v":0},{"$f":"Calculation!N23*$C$2","v":0},{"$f":"Calculation!O23*$C$2","v":0}]
[null,"Other",{"$f":"Calculation!H24*$C$2","v":8.1137241197036047},{"$f":"Calculation!K24*$C$2","v":0},{"$f":"Calculation!L24*$C$2","v":0},{"$f":"Calculation!M24*$C$2","v":0},{"$f":"Calculation!N24*$C$2","v":0},{"$f":"Calculation!O24*$C$2","v":0}]

{"sheet":"Calculation","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"total change in spend (1% of the budget)",{"$f":"0.01*F25","v":783.98}]
[null,null,null,null,null,"total spend (2008/09), £m","spend elasticities (adjusted)","change in spend","Total deaths (2008-2010)","outcome elasticities","change in deaths","change in LY","change in QALY (total)","change in QALY (dead)","change in QALY (alive)"]
[null,2,null,2,"Cancer",4843,0.72434524892893248,{"$f":"F3*G3*0.01","v":35.080040405628203},131945,0.307,{"$f":"I3*J3*0.01*G3","v":293.41136298067892},2940.1531587367786,2063.8794314706397,1911.8668712646349,152.01256020600471]
[null,10,null,10,"Circulatory ",6655,0.89404899296371099,{"$f":"F4*G4*0.01","v":59.498960481734969},151443,1.319,{"$f":"I4*J4*0.01*G4","v":1785.8925190501093},9092.4710734852979,8453.4558837398872,5777.965362597768,2675.4905211421196]
[null,11,null,11,"Respiratory ",3994,0.89956781390793139,{"$f":"F5*G5*0.01","v":35.928738487482782},64449,1.8080000000000001,1048.2105283770252,1259.4011167826675,17980.67318488799,788.62593453618717,17192.047250351803]
[null,13,null,13,"Gastro-intestinal ",3989,0.62914558764112993,25.096617491004672,23897,1.3640000000000001,205.07320035121151,1933.0278387516273,3441.0589885769405,1268.3399080665999,2172.7190805103405]
[null,1,null,1,"Infectious diseases",1201,2.1316445897051439,25.60105152235878,5262,0.504,56.532237708383484,416.77714275642541,1229.1122705585349,281.78226642542802,947.33000413310697]
[null,4,null,4,"Endocrine ",2222,0.66777733425067298,14.838012367049954,6762,1.17,52.831470910175696,389.21883048126404,4749.08719483603,254.43619853299066,4494.6509963030394]
[null,7,null,7,"Neurological ",3466,1.3521111313340073,46.864171812036695,16771,0.41699999999999998,94.559986617622982,507.83712719873733,8551.2056670508318,334.69548496989444,8216.5101820809377]
[null,17,null,17,"Genito-urinary ",3779,0.96165454953041118,36.340925426754239,11345,1.615,176.1960294604236,256.3801344939053,829.46073961107857,161.85478617179112,667.60595343928742]
[null,16,null,16,"Trauma & injuries*",3255,1.8543238372580673,60.358240902750083,0,0,0,0,0,0,0]
[null,"18+19",null,"18+19","Maternity & neonates*",3978,1.3452126051537316,53.512557433015445,265,0.125,0.44560167545717361,33.262144976359565,36.045003926964917,24.802933240557252,11.242070686407663]
[null,3,null,3,"Disorders of Blood",998,1.6156348314205331,16.124035617576919,null,null,28.601369519039864,129.62540788781345,1711.9132313792334,88.059712777304881,1623.8535186019283]
[null,5,null,5,"Mental Health ",9794,1.4293746245530934,139.99295072872997,null,null,222.09538769767096,1006.5673673824521,7468.7203067426326,651.82464521888949,6816.8956615237366]
[null,6,null,6,"Learning Disability",2874,0.28283957339129739,8.1288093392658869,null,null,3.4175093231910667,15.488630349821044,54.234269246847717,10.710318702802486,43.523950544045242]
[null,8,null,8,"Problems of Vision",1688,0.90232722438004165,15.231283547535105,null,null,4.0547919973409741,18.376884582595675,332.64981332051337,13.169566647009308,319.48024667350404]
[null,9,null,9,"Problems of Hearing",417,1.6432289361416355,6.8522646637106197,null,null,2.5393633781902101,11.508750077654739,1098.2824574648275,8.3047728595762642,1089.9776846052512]
[null,12,null,12,"Dental problems",3198,0.70778878609627116,22.635085379358753,null,null,0.17587025903734466,0.79706861756655156,532.94503145260626,0.51012187481604321,532.43490957779011]
[null,14,null,14,"Skin",1657,0.92992132910114378,15.408796423205953,null,null,19.163484329841271,86.851591884568805,152.49838334316826,56.127585648525773,96.370797694642391]
[null,15,null,15,"Musculo skeletal ",4081,0.69675114420783024,28.434414195121555,null,null,30.609885374492261,138.72828272878357,1819.4857529261021,90.399052837054541,1729.0867000890471]
[null,20,null,20,"Poisoning and AE",938,0.77539434266297158,7.2731989341786729,null,null,3.5214626176929351,15.95976122319116,64.055143763294083,10.428111959903225,53.62703180339085]
[null,21,null,21,"Healthy Individuals",1831,1.5135366439524549,27.712855950769448,null,null,2.6469449091926522,11.996324626422538,52.608959815693765,8.2230227088830414,44.385937106810715]
[null,22,null,22,"Social Care Needs",1874,1.2569114700462047,23.554520948665878,null,null,0,0,0,0,0]
[null,23,null,23,"Other",11666,0.68157438661122405,79.512467942065399,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F3:F24)","v":78398},null,{"$f":"SUM(H3:H24)","v":783.98},null,null,{"$f":"SUM(K3:K24)","v":4029.9790065367779},{"$f":"SUM(L3:L24)","v":18264.428637023928},{"$f":"SUM(M3:M24)","v":60621.371714113811},{"$f":"SUM(N3:N24)","v":11742.126657040617},{"$f":"SUM(O3:O24)","v":48879.245057073196}]
[null,null,null,null,"Threshold cost",null,null,null,null,null,null,null,{"$f":"$H$25*1000000/M25","v":12932.402844613865}]
[]
[null,null,"AUXILIARY DATA"]
[]
[]
[null,null,null,null,"YLL per death averted ",null,4.532139896361322]